/****** Object:  Endpoint [ep_esportazione]    Script Date: 04/11/2014 15:52:59 ******/
IF  EXISTS (SELECT * FROM sys.endpoints e WHERE e.name = N'ep_esportazione') 
DROP ENDPOINT [ep_esportazione]
GO

/****** Object:  Endpoint [ep_esportazione]    Script Date: 04/11/2014 15:52:59 ******/
CREATE ENDPOINT [ep_esportazione] 
	AUTHORIZATION [sa]
	STATE=STARTED
	AS HTTP (PATH=N'/export', PORTS = (CLEAR), AUTHENTICATION = (NTLM, KERBEROS, INTEGRATED), SITE=N'*', CLEAR_PORT = 8080, COMPRESSION=DISABLED)
	FOR SOAP (
WEBMETHOD 'http://tempuri.org/'.'agenzie'( NAME=N'[caronte2014].[dbo].[dbws_exportAgenzie]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'biglietti_convenzioni'( NAME=N'[caronte2014].[dbo].[dbws_exportBigliettiConvenzioni]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'causali_movimenti'( NAME=N'[caronte2014].[dbo].[dbws_exportCausaliMovimenti]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'fido'( NAME=N'[caronte2014].[dbo].[dbws_updateFidoAgenzia]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'itinerari'( NAME=N'[caronte2014].[dbo].[dbws_exportItinerari]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'linee'( NAME=N'[caronte2014].[dbo].[dbws_exportLinee]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'macroregioni'( NAME=N'[caronte2014].[dbo].[dbws_exportMacroregioni]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'movimenti'( NAME=N'[caronte2014].[dbo].[dbws_exportMovimentiDareAvere]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'movimenti_dettaglio'( NAME=N'[caronte2014].[dbo].[dbws_exportPrenotazioniDettagli]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'operatori'( NAME=N'[caronte2014].[dbo].[dbws_exportOperatori]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'polizze'( NAME=N'[caronte2014].[dbo].[dbws_exportPolizze]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'polizze_dettaglio_diritti'( NAME=N'[caronte2014].[dbo].[dbws_exportPolizzaDettDiritti]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'polizze_veicoli'( NAME=N'[caronte2014].[dbo].[dbws_exportPolizzeVeicoli]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'saldo'( NAME=N'[caronte2014].[dbo].[dbws_updateSaldoAgenzia]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), 
WEBMETHOD 'http://tempuri.org/'.'tipo_biglietteria'( NAME=N'[caronte2014].[dbo].[dbws_exportTipoBiglietteria]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), BATCHES=ENABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=DEFAULT, NAMESPACE=N'http://tempuri.org', SCHEMA=STANDARD, CHARACTER_SET=XML)
GO


GRANT CONNECT ON ENDPOINT::ep_esportazione  TO [MARESQL\sys_erpuser]
GO
GRANT CONTROL ON ENDPOINT::ep_esportazione  TO [MARESQL\sys_erpuser]
GO

sp_reserve_http_namespace N'http://MARESQL:8080/export'
GO